package com.htht.job.executor.dao.productfileinfo;

import com.htht.job.executor.model.productfileinfo.ProductFileInfo;
import org.jeesys.common.jpa.dao.string.BaseDao;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

/**
 * Created by zzj on 2018/1/2.
 */
public interface ProductFileInfoDao extends BaseDao<ProductFileInfo> {
    @Modifying
    @Query(nativeQuery = true,value = "DELETE FROM htht_product_file_info WHERE " +
            "  product_id = :productId and issue =:issue  ")
    void deleteByissue(@Param("productId") String productId,@Param("issue") String issue);
}
